orcli export template

export to any text format by providing your own GREL template

Usage

Arguments

PROJECT		`project name or id (required)`
FILE		`Path to row/record template file or URL. When FILE is -, read standard input.`

Options

--separator SEPARATOR		`insert character(s) between rows/records`
--prefix PREFIX		`insert character(s) at the beginning of the file`
--suffix SUFFIX		`insert character(s) at the end of the file`
--mode MODE		`specify if project contains multi-row records`
--facets FACETS		`filter result set by providing an OpenRefine facets config in json`
--output FILE		`Write to file instead of stdout`
--encoding ENCODING		`set character encoding`
--quiet, -q		`suppress log output, print errors only`

Parent Environment Variables

OPENREFINE_URL URL to OpenRefine server

Examples

orcli export template "duplicates" "template.txt"

cat "template.txt" | orcli export template "duplicates"

orcli export template "duplicates" "https://example.com/template.txt"

orcli export template "duplicates" "template.txt" --output "duplicates.tsv"

orcli export template "duplicates" \
  <<< '{ "name" : {{jsonize(cells["name"].value)}}, "purchase" : {{jsonize(cells["purchase"].value)}} }' \
  --prefix '{ "events" : [' \
  --separator , \
  --mode records \
  --suffix ]}$'\\\n' \
  --facets '[ { "type": "text", "columnName": "name", "mode": "regex", "caseSensitive": false, "invert": false, "query": "^Ben" } ]' \
  | jq